Carson Penticuff Community Champion

Overview

Overview

Roles	Member
Badges	38

About Me

About Me

Not much happening here, yet.

Analytics

869

Posts

1,638

Visits

2.8k

Points

May 23, 2023

Join Date

Mar 5, 2025

Last Active

Reactions

• Insightful 25

  25
• Vote Up 93

  93
• Awesome 154

  154

• Activity
• Discussions2
• Comments867

• Re: Impossible to countifs on an empty column

  Carson Penticuff

  07/13/23
  Try tucking the last condition inside the COUNTIFS closing paren. =IF(ISBLANK([Name of LE]@row), "", COUNTIFS({Fn}, "HR", {LEC - Action list conso pivot Range 1}, CONTAINS([Region…
  1 ·

• Re: Excluding Weekends from Date formulas?

  Carson Penticuff

  06/27/23
  Okay, I think I get what you are saying now. These two formulas would replace the ones in your screenshots. =IFERROR(WORKDAY([Start Date]11, -CEILING([Delay (Days)]@row + [Duration (Days)]@row, 1)), …
  1 ·

• Re: OR in COUNTIFS Formula

  Carson Penticuff

  06/20/23
  Remember that the syntax for the COUNTIFS function is COUNTIFS(range 1, logical statement 1, range 2, logical statement 2, etc etc etc. {status}, OR(@cell = "Repaired", @cell = "Beyond…
  1 ·

• Re: Workflow History

  Carson Penticuff

  06/12/23
  The activity log for the sheet will give you some information. If it affects other sheets, their activity logs may also provide some insight.
  1 ·

Previous